package com.jash.labor.mapper.provider;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;

public class SqlStationEnrollProvider {
    public String laborQueryStationList(Page page, String content){
        String sql = "select s.name,s.salary_start,s.salary_end,requirements,f.location,c.mobile \n" +
                " from company c,first_party f,station_enroll se,station s \n" +
                " where se.labor_id = '%"+content+"%' and se.station_id = s.id \n" +
                " and f.id = s.first_party_id and c.id = f.company_id ";
        sql += "order by s.id desc";
        return sql;
    }
}
